From Relational Databases to NoSQL Databases: Performance Evaluation
نویسندگان
چکیده
In nowadays applications, the amount of data in the database grows exponentially. So, the DBMS must process these huge amounts of data as fast as possible. The main aim of this study is to prove that NoSQL databases process big data faster than relational database. The changing in applications, user and infrastructure characteristics, mostly of the Web 2.0 domain and cloud platform, led to explosion of data sources and massive workloads. These huge amounts of data have raised the problems of storage and usability of data as the usual Relational Database Management Systems (RDBMS) were unable to handle the exponentially growing data on a single in house server (vertical scalability). Furthermore, the required time to process these big data is an issue. The study implements prototype which verifies performance argument. The performance evaluation compares the insertion and retrieval speeds between MongoDB as NoSQL database and MySQL as relational database. The benchmarking performed shows that MongoDB is faster than MySQL in the most of scenarios we chose, particularly when we deal with huge amount of data.
منابع مشابه
Data Migration: Relational Rdbms to Non-relational Nosql
As a part of achieving specific targets, business decision making involves processing and analyzing large volumes of data that leads to growing enterprise databases day by day. Considering the size and complexity of the databases used in today’s enterprises, it is a major challenge for enterprises to re-engineering their applications that can handle large amounts of data. Compared to traditiona...
متن کاملExperimental Evaluation of Nosql Databases
Relational databases are a technology used universally that enables storage, management and retrieval of varied data schemas. However, execution of requests can become a lengthy and inefficient process for some large databases. Moreover, storing large amounts of data requires servers with larger capacities and scalability capabilities. Relational databases have limitations to deal with scalabil...
متن کاملCombining Relational and Semi-structured Databases for an Inquiry Application
The popularity of NoSQL databases keeps growing and more companies have been moving away from relational databases to nonrelational NoSQL databases. In this paper, the partitioning of a relational data model of an inquiry system into semi-structured and relational data for storage in both SQL and NoSQL databases is shown. Furthermore, the CAP theorem will be applied to categorize the storing of...
متن کاملBusiness Intelligence and Nosql Databases
NoSQL databases become more and more popular, not only in typical Internet applications. They allow to store large volumes of data (so called big data), while ensuring fast retrieving and fast appending. The main disadvantage of NoSQL databases is that they do not use relational model of data and usually do not offer any declarative query language similar to SQL. This raises the question how No...
متن کاملNOSQL Design for Analytical Workloads: Variability Matters
Big Data has recently gained popularity and has strongly questioned relational databases as universal storage systems, especially in the presence of analytical workloads. As result, co-relational alternatives, commonly known as NOSQL (Not Only SQL) databases, are extensively used for Big Data. As the primary focus of NOSQL is on performance, NOSQL databases are directly designed at the physical...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015